System Schema Extension Modification Registry Schema Extension Modification Registry view Actions Customize System Entity for Dynamic Flex Fields Customize System Entity form Current Fields tab Modification Field formAdministration System Schema Extension Modification Registry Schema Extension Modification Registry view Actions Customize System Entity for Dynamic Flex Fields Customize System Entity form Current Fields tab Modification Field form
You use the Modification Field form to add or edit dynamic flex fields.
After a field has been applied to the database, you can no longer change the field type, column name, and column length.
To add or edit a field to a system entity:
Select the Enabled check box to add the modification to the schema update.
In the fields, provide the following information:
Field Id: Enter the ID to be used to uniquely identify this field in the entire application.
This field is prepopulated with a set prefix to enforce naming conventions (on page 1). If you remove this prefix, you cannot save your changes.
Current Database Column Name: Enter the name of the database column.
The column name is limited to database specifications. This field is prepopulated with a set prefix to enforce naming conventions (on page 1). If you remove this prefix, you cannot save your changes.
Do not to use the keyword ‘FROM’ as a database column name when extending schemas in N4. This keyword is subject to limitations related to the logic used to separate tables in SQL query reports.
Field Name: Enter the name of the field.
Field Desc: Enter the description of the field.
Field Type: Select the field type. For more information on the field types supported, see Supported data types (on page 1).
The field type you select affects the Field Class Name and Current Column Length fields.
Field Class Name: If the field type is Built-in enumeration or Many-to-one, select the field class from this lookup field. For all other field types, this field is unavailable because N4 automatically matches the field class name.
Current Column Length: If the field type is String, enter the current length of the database column. For all other field types, this field is unavailable.
You cannot modify the column length of a field if the snapshot has already been applied to the database. If you need to modify this field, you must first remove it from the database and then re-apply the snapshot with your modifications.
Click Save.